SQL Serverの一時テーブルのスニペット

code:sql

drop table #ITEMS;

code:sql

create table #ITEMS(

created_at_string varchar (20)

, id int

, category_id int

, item varchar (8)

, created_at datetime2

primary key (created_at_string, id, category_id)

);

code:sql

truncate table #ITEMS;

code:sql

insert

values ('20241001', 10, 20, 'Apple', sysdatetime())

, ('20241001', 10, 25, 'Banana', sysdatetime())

, ('20241001', 10, 23, 'Orange', sysdatetime());

code:sql

select * from #ITEMS;